Import CSV
Overview
This function lets you enter data from comma separated value files directly
into Lotto Sorcerer. 'Comma separated value files' are files where the data
fields are separated by a comma. These files typically have an file
extension of '.csv'. Note that this expects the data to have the drawing
date first, then the numbers drawn. If it is a bonus ball type lottery, it
expects the final number(s) to be the bonus ball(s).
Any errors while importing will be displayed in the "Error Log" section at
the bottom of this window.
How to Invoke
Use the menu item "Lottery Data > Import Lottery Data > Import Comma Separated Value (CSV) File" .
Basic Procedure
- Set the input parameters of the comma separated value file.
- Select the input file.
- Click the "Import" button.
Window Controls
"Select Lottery" dropdown
Use this dropdown to select the lottery that you want to import data to.
"Date Format" dropdown
This allows you to select how the drawing date format.
"Character between Date Elements" dropdown
This allows you to select the character that is between the date elements
(month, day and year). The default is the slash ('/').
"Ignore First Line" check box
Some delimited text files use the first line to describe the field layout.
If your input file has this, check this box.
"Expected Input Format" box
Based on your previous selections, this box shows, using dummy data, how it
expects the input file to look. Note that the tab character is represented
as "[tab]" .
"Select Input File" button
Clicking this button brings up a standard file selector. Choose the file you
want to import.
"Actual Input Format" box
Based on the file you selected, this box shows an actual preview of the
first few lines of that file. It is important that this box closely
resembles what is in the "Expected Input Format" box.
"Import" button
Clicking this button imports the file you have chosen into Lotto Sorcerer's
database.
"Cancel" button
Use this to close the current window and return to the Main window.